home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
SPREOTUS
/
SPEDCORS.LZH
/
L9
< prev
next >
Wrap
Text File
|
1992-06-06
|
5KB
|
199 lines
March 26, 19921L9
╔════════════════╗
║ THE READY MODE ║
╚════════════════╝
√√√ HIGHLIGHTING
(Also Called Reverse Video)
▀ The cell that is in use on the spreadsheet will
have a reverse color (video). It will stand out from
the rest of the spreadsheet.
This is called highlighting or reverse video.
The cell that is highlighted will always have the flashing
cursor-bar (called underscore bar). It is in this box
that your next data will be stored. The flashing cursor is
telling you that it is waiting for you to enter a command.
√√√ THE READY MODE
▀ You must be in the Ready Mode to start entering data.
The upper right corner of the worksheet has a small box
that shows what mode you are in.
▀ If you are not in the "Ready Mode" press the Esc key
once or twice.
▀ In the ready mode the screen is clear except for the
empty worksheet.
You must be in the Ready mode for the next lesson.
√√√ HOW TO GET INTO THE READY MODE
▀ Press the Esc key several times. You will see the word
"READY" highlighted in the upper right-hand corner.
▀ Another method is to keep pressing the Enter key. It will
reach the Ready mode.
√√√ THE MATH SYMBOL HIERARCHY (Who's first)
Lotus uses many math functions like multiply, divide, add and
subtract. To use these functions (called operators)
correctly the computer must know the order of priority.
When there is more than one math function in a formula
the computer must decide which has the priority so that it
will not be adding when it should be multiplying.
An Operator is a symbol that represents a mathematical function
like multiply or add. These symbols are used with the cell
addresses to create formulas: for example +A1-B1.
The math symbols that you will be using are listed in the order
that the computer will execute them.
Exponentials (like 2 to the second Power.. 2x2 and written 2^)
has the first priority. It is represented by the
Caret symbol (^) from the top of key 6. The symbols are listed below:
- 4 -
THE MATH SYMBOL HIERARCHY
▀ First ^ Exponential
▀ Second * Multiplication
▀ Third \ Division
▀ Fourth + Addition
▀ Fifth - Subtraction
Some Examples:
+A3+A4+A5+A6+A7...same as...
@SUM(A3..A7)
The formula @SUM(A3..A7) means add
together all the numbers contained in
cells A3, A4, A5, A6, AND A7.
▀ If you have this: +A2-B3*2 you
would multiply the B3 by 2, then subtract from A2.
▀ But if you isolate the A2-B3 by
putting it in parenthesis like this:
(A2-B3)*2, then you would first
subtract B3 from A2, then multiply by 2.
The parenthesis means do me first.
√√√ MORE EXAMPLES
▀ 34*C7, Is 34 times the content of cell C7.
▀ 345/D5 Is 345 divided by
content of cell D5.
▀ +B3+C3 Is adding B3 to C3. A
cell must have a plus or minus
if it is the first item.
▀ -F6+H8 Subtract F6 from H8.
▀ 3^2 Is 3 to the second power (3 X 3 =9).
√√√ ENTERING AND EDITING DATA
When you enter data into a cell 1-2-3 classifies each
entry as one of two types: labels or values.
▀ Labels are text entries.
▀ Values are numbers and formula entries.
√√√ LABELS
A label is a text entry . It can include any combination
of characters such as a name, address, numbers,
and numeric symbols:
for example: Jane Thompson, 345 Hickory St,
33550, and $5.07 can all be entered as labels.
√√√ LABEL PREFIX
Every label has a label prefix. They are used with
labels for special effects. They control the label's
position in a cell.
The caret (^) centers the label in a cell.
The backslash (\) repeats characters in
the label to fill Cell.
The Apostrophe is the default label prefix.
If you don't enter it 1-2-3 does it for you.
It aligns the label with left edge of a Cell.
- 5 -
√√√ VALUES
A value is an entry that begins with a number (0 to 9),
or one of the numeric symbols.
These symbols are called Values: + - @ # $ . ( .
The entry can be a number or a formula.
You must precede the prefixes with an
apostrophe (') to make it a Label.
*** END OF CHAPTER ***
Press Esc key to return to Menu.
Select "HOW TO START", then press <Enter> key.
- 6 -